home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 7 / developer source - volume 7.iso / dbmsa / feb97 / spitf101.gif < prev   
Graphics Interchange Format  |  1997-06-26  |  38KB  |  356x307  |  4-bit (16 colors)
Labels: text | electronics | screenshot | display | software | web page | parallel | number
OCR: Effi Yww Tools Sowah Query Window Help order_id 6131:5 company custid contact lemp_id Cottimir ant id SELECT Customer, country, SUM(Orders.order_axt) AS regional sales! FROM testdataicustomer INNER JOIN testdatalorders ; ON Customer, cust id = Orders.cust id! MIERS Orders.emp_id = temployee.exp_id; GROUP BY Customer.country Figure 1. Microsoft Visual FoxPro 5.0 now supports the ANSI SQL-92 JOIN syntax, which appears in the FROM clause instead of the WHERE clause. The JOIN syntax also supports left and right outer joins.